Given below is the data (Notice that some of the Ids are repeating) :
I want the output as follows:
ID | Field1 | Field2 |
1 | 10 | -10 |
2 | 20 | -20 |
3 | 30 | 15 |
4 | 40 | 20 |
5 | 50 | 100 |
6 | 60 | 120 |
7 | 5 | |
8 | 5 |
So basically I require a new filed that will represent data based on common ID as shown in above snip.
Thanking in advance.
Regards,
Chirag
Solved! Go to Solution.
@Chirag_KRCPL
I was thinking to use the Tile tool but considering the case of same value for same ID, I chose to use the Multirow formula tool.
Hi, @Chirag_KRCPL
If you only want get split , there is have a easy way:
Input | Output | ||||
ID | Value | ID | Column_1_Value | Column_2_Value | |
1 | 10 | 1 | 10 | -10 | |
2 | 20 | 2 | 20 | -20 | |
3 | 30 | 3 | 30 | 15 | |
4 | 40 | 4 | 40 | 20 | |
5 | 50 | 5 | 50 | 100 | |
6 | 60 | 6 | 60 | 120 | |
1 | -10 | 7 | 5 | ||
2 | -20 | 8 | 5 | ||
3 | 15 | ||||
4 | 20 | ||||
5 | 100 | ||||
6 | 120 | ||||
7 | 5 | ||||
8 | 5 |
********
If it can help you, please mark it as a solution for share more.
@flying008 can you please share this workflow (one with tile & dynamic rename). It would be a great help!
Hi, @Chirag_KRCPL
1-2 Tile + Transpose set in below:
3- Dynamic Rename Expression:
iif(REGEX_Match([_CurrentField_], "^\d+$"),"Field" + [_CurrentField_], [_CurrentField_])