Warn
Key: RecordID
Data: All Selected Fields
___RecordID___
1
Int32
6
0
RecordID
Group By:
RecordID
RightInputRows
Ignore
Mapped
Name
New Name
Rename fields found with zero non-null values
Delete Null Rows?
1
Custom
pass zero records
1
Keep only records not found with zero non-null values
Simple
CountNonNull_Value
=
0
[CountNonNull_Value] = 0
Group By:
Name
Delete Null Columns?
1
Custom
pass zero records
1
Simple
CountNonNull_Value
=
0
[CountNonNull_Value] = 0
Formula
!StartsWith([Name],"___Delete___")
AND
[Name]!="___RecordID___"
Deselect fields
___RecordID___ - Ascending
Output36
All
[_CurrentField_]
Convert all fields to Bool data type
[_CurrentField_]
C:\Users\502774122\Desktop\48TD.xlsx|||`Sheet2$`
False
1
48TD.xlsx
Table=`Sheet2$`
C:\Users\502774122\Desktop\TB_All.xlsx|||`Sheet1$`
False
1
TB_All.xlsx
Table=`Sheet1$`
"ME","Account","Description","Functional_AUD","Functional_CNY","Functional_CNY2","Functional_EUR","Functional_HKD","Functional_IDR","Functional_JPY","Functional_KRW","Functional_MYR","Functional_PHP","Functional_SGD","Functional_THB","Functional_USD","Functional_USD2","Functional_VND","Reporting_USD"
True
False
True
False
False
False
False
False
False
upper
Warning
All
ByName
Horizontal
Question
Check Box (11)
Question
Check Box (33)
Question
Macro Output (36)
Question
List Box (39)
提问
NoCondition
(Always Run)
Dynamic
{{INPUT}}
15/DetourRight/@value
Update Detour Direction from Question
Expression
Dynamic
{{INPUT}}
24/DetourRight/@value
Update Detour Direction from Question
Expression
UpdateFieldList
4/DataFields
Tab
Questions
Tab (10)
BooleanGroup
Delete Null Rows
Check Box (11)
BooleanGroup
Delete Null Columns
Check Box (33)
MacroOutput
Macro Output (36)
Macro Output (36)
ListBox
Select Fields to check
List Box (39)
Field
Output
Bool,Byte,Int16,Int32,Int64,FixedDecimal,Float,Double,String,WString,V_String,V_WString,Date,Time,DateTime,Blob,SpatialObj
Macro