How do I move my data to the left of those Nulls?

[yuanming1992]

Hi guys,

How do i move those values in test23 columns to the Nulls in test22? I need to keep that test22 header because I am using dynamic rename for that header

Appreciate your help.

[ShankerV]

Hi @yuanming1992 

One way of doing this.

Note: Remove the middle column using select tool, if not needed in the output.

Step 1:

 

Step 2:

 

Step 3:

Many thanks

Shanker V

[BRRLL99]

let me know if this is your final output which you are looking for

F2	test22	test23
1 year	0	0
2 year	235	235
3 year	222	5352
4 year	35	1234
5 year	231	55
6	345	66
7	0	0
8	0	0
test1	0	32
test2	0	1
test3	0	35
1 year	0	0
2 year	235	235
3 year	5352	5352
4 year	1234	1234
5 year	55	55
6	66	66
7	0	0
8	0	0
test1	32	32
test2	1	1
test3	35	35

[yuanming1992]

what's in your Select Records tool?

[ShankerV · Accepted solution]

Hi @yuanming1992 

Please find the Configuration in Select tool,

Many thanks

Shanker V 

[flying008 · Accepted solution]

Hi, @yuanming1992 

FYI.

F2	test22
1 year	0
2 year	235
3 year	222
4 year	35
5 year	231
6	345
7	0
8	0
test1	0
test2	0
test3	0
1 year	0
2 year	235
3 year	5352
4 year	1234
5 year	55
6	66
7	0
8	0
test1	32
test2	1
test3	35

[yuanming1992]

Thank you so much for your help.

Is there a way I can keep that test22 as header?  the reason to keep this is because I am using dynamic rename tool for this header. 

[ShankerV]

Hi @yuanming1992 

Yes, we can achieve with the help of same Select tool.

Please find the below.

 

[yuanming1992]

this wf is in macro and is there a way to do it more dynamic on that filter tool? that test22 could be test23, test24, test25 and so on.

I am using dynamic rename to get that test22 so I can't just use that test22 in that filter because it will change to other names like I mentioned above.

Thank you for your help