Filtering the columns that will be appended
Step created to identify and rename all columns Not Applicable to unselect automatically with dynamic select
Code
Name
Company A
Not Applicable
Not Applicable
Company D
1
A
340
450
520
630
2
B
340
450
520
630
1
Warn
renaming column names
RightInputRows
Warn
Mapped
Name
Rename
Formula
!contains([Name],'Remove')
Simple
=
Value
True
fixed
2020-01-15 02:01:07
0
2020-01-15 02:01:07
2020-01-15 02:01:07
Not Applicable
[Value] = "Not Applicable"
,
Error
0
Warning
All
ByName
Workaround to sort columns automatically
C:\Users\FERNAN~1.VIZ\AppData\Local\Temp\Engine_6860_8c4e7d9d96224ced9fc8b066606f51c4_\Engine_6644_8515ffdfb46644ff9009ef9f82462da1_.yxdb
Single
Profile
Horizontal
2020-01-15 Developing a Macro for filling down values for multiple fields