Multiple columns creating

Help Studio
, ,
1

Hi All, I am merging multiple datable using the merge data table activity but after completion, I can see extra blank columns created like column 1 and column 2…

I am not sure why it’s happening. Please, anyone, have any solution leet me know

2

Hi @pankajmohan.dhane ,

Could you maybe check the Datatable values in Debug Panel and check whether there are blank column values are present ?

3

Use Remove Data column Activity after merging two Data tables.

4

I am getting 70 columns but anyways it resolved now.

1 Like
5

Hi @pankajmohan.dhane , could you kindly explain how you resolved your issue if you get the chance?

I was going to suggest modifying the input tables to make sure that they have the same number and name of columns, or modifying the Missing Schema Action property of the merge activity.

If all else failed, you could loop through your columns and remove any that are not those you expect.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.