CREATING NEW COLUMN

[srk0609]

Hi Everyone,

Can you please help me get this is as output. I am including input file. Thank you for help.

UNIQUE ID

SHOP:12345678

SHOP:12345679.12345680

SHOP:12345679.12345681

[binuacs · Accepted solution]

@srk0609 Are you looking for something like below

[DataNath]

@srk0609 without any logic or explanations of the steps to make this dynamic, it's pretty much impossible to figure out what you want.

If you literally just want that as an output and don't care how then you can use attached workflow:

[srk0609]

The solution works only logic was if there is value in both ID_1 and ID_2 columns I want to concat value with SHOP. If there is value only in ID_1 we want to concat that to SHOP