IN Praise of V2 - Adding new columns

Question
1

I had a decent heavy transformation , where I had to add a column in one of the starting files (poheader) , I was dreading It , considering how much re-work I have to do in joins and lookups.

I was surprised with V2 , all my joins , lookups very preserved downstream inspite of adding columns !!

Thanks @Admin for saving my 30 minutes atleast :blush:

CleanShot 2025-02-26 at 22.56.38
CleanShot 2025-02-26 at 22.56.38617×655 137 KB

2 Likes
2

We are doing our best to smooth off the rough edges!

1 Like
3

I want to second that. Downstream stability to changes is massively improved and that’s very helpful!

There is one thing that could be improved from my point of view… if you add a “New Col” transform before any “Remove Cols”, the new col will be marked removed in all following “Remove Cols” transforms… I think it is pretty obvious that a column added later should be present, not removed

Please consider this

Best,
Jochen

1 Like
4

I think there are situations where this won’t be the right choice. So it should probably be configurable.

It is on the wishlist to have an option in Remove Cols as to whether any columns added upstream should be checked or unchecked (currently they are unchecked, so not propagated).

2 Likes