Hello,
I have an input data which looks like this:
Code | value |
21 | 1324 |
Z4 | 3564 |
L3 | 6798 |
34 | 9867 |
LP | 5423 |
98 | 4459 |
2T1 | 1121 |
11 | 4112 |
I output should look like this (exactly in this order):
Code | Value |
2T1 | 1121 |
Z4 | 3564 |
25 | Null |
11 | 4112 |
98 | 4459 |
16 | Null |
21 | 1324 |
L3 | 6798 |
34 | 9867 |
Input file can change time to time and might always contain the same codes while the output format is always the same.
I want the values to be filled in output file when the code exists in the input and all the codes that do not exist in input file should be Null or blank.
I have used the filter tool but it returnes a empty data if the criteria is not fullfilled, for example " [Code]= "16" " within a filter will return an empty data considering that code 16 does not exist in the input file.
any ideas for a solution?
thanks in advance,
Tony
Solved! Go to Solution.
Yes, Tank you, the only think which is not right at the end is the order of codes, I want them in this order:
2T1
Z4
25
11
98
16
21
L3
34
Possible to fix?
@TonyMu You just need a record ID, sort, and select added to the workflow that @joshuaburkhow provided to get your desired results.
you guys are just amazing! thanks thats what I need!