Forum Discussion
Create columns in a list
I have a query that comes from multiple databases with many columns each. From the query I want to extract 10 columns (number of projects) The problem is that in the future there will be more proje...
Of course.
On the one hand I have a query with many columns, most of them do not serve me. When it comes to expanding the query, I could filter only by the ones I need, but in the future I will need other new columns, so in order for them to appear in the report, I would need to go back to the transformer and select the new columns:
On the other hand I have a list with the columns I need. In the future, when there are new projects, I will include them in this list:
I would like, that when expanding I only take the columns that match the names of the list. It's possible?
Thanks a lot!
This would be the list