Hello Experts,
I want to achieve the below for a Data Load Scenario:
Example: I have 5 Columns (ID, Column 1, Column 2, Column 3, Column4 ) i need to create a new Column based on the Four Columns (Column 1, Column 2, Column 3, Column4 ). If there is any data available in that 4 columns, then the new column should have the Data from the 4 columns seperated by comma, if theres no data available in 4 columns then the New column should display as Blank. (See Below for Example Scenario).
Appreciate our help: Example Table Scenario:
ID | Column1 | Column2 | Column3 | Column | Output New Column |
1 | A | | C | | A,C |
2 | A | B | C | D | A,B,C,D |
3 | | D | C | | D,C |
4 | | | | | **EMPTY** |
5 | A | B | | D | A,B,D |
Thanks.