Removing certain field in the output rendering

[SH_94]

HI community,

My input data always have different field and i would like to ask how to remove certain field in the output. For instance, I want to remove Year Period and country in this case. I plan to use select tool but it is not dynamic because  i may want to exclude those unwanted field in the future. May i know what is the best approach to remove unwanted more dynamically since my input data always have diferent field.

Input

Company Code

Year

Periord

Year Period

Amount

Time

Location

Country

ID

Output

Company Code

Year

Periord

Amount

Time

Location

ID

Thank you 

[PangHC]

you can uncheck the *unknown in the end of select tool.

it will exclude all new field.

[sparksun · Accepted solution]

Dynamic Select tool is perfect for your case.

[SH_94]

Hi @sparksun,

Thank you for the input. Can you share with me the workflow so that i can take a look on this more detail?

After dynamic tool, do i still able to see the whole data again, meaning data in other field that i want to render out?

Thanks again.

[PangHC]

share some sample date please.