Excel output columns selection

[MahanteshS]

Hi Guys,

Requirement:

Input File : Excel file with 10 columns

Condition : If total row "count >= 5" then

If TRUE --> Write output with all 10 columns

If FALSE --> Write output with 9 columns. ( I have to remove one column, in this case)

Output file should be only one file.

Solution tried: 

I have used Filter and select tool then at the end if i use union not able to get only 9 columns.

PFA screenshot,

[Vijuzy]

May be attached workflow helps! When you union all your files, you may still get null values in the rows coming from the file, where have removed field (count is less then 5).

Regards,

Vijay

[GowthamRaja]

Please see a way , we can differentiate the file based on row filter...

[MahanteshS]

yeah, that is the problem, I don't want those null columns in the end output

[GowthamRaja]

Try using Dynamic Select Tool From Developer Section.. Its helps you to select the columns in dynamic fashion.

[MahanteshS]

But this dynamic selection is allowing based on the only on "Data Type".

So, In my requirement, it will not help

[GowthamRaja]

You can write a formula in Dynamic Select Tool, Check for the drop down. In That Formula you have to write for the logic to pick your columns....

This would work in your case.