Input29
1
BEYLAT
123456
1234567.10
12
2
SILHOL
789456
1231321.12
1
3a
123456
1254788.45
15645
Values to test
Values to test
Input30
E
Id
Int32
True
10
1
Name
String
True
38
1
SIRET
Int32
False
6
6
Amount
Int32
False
10
0
Quantity
Double
False
14
0
Extra
String
False
10
10
Text Input (9)
Expected structure
Warn
Key: RecordID
Data: All Other Fields
[Length]
[Is Number]
[Has Decimal]
Length=Length([Value])
Is Number=IsInteger(ReplaceChar([Value], '.', '')) OR IsEmpty...
Has Decimal=[Is Number] and Contains([Value], '.')
1
__RecordID__
Int32
0
C:\Users\JOEMAK~1\AppData\Local\Temp\Engine_4312_42e87514613548d78f740b15a12ecb2b_\Engine_3944_31a6d81fa20349b588e85257cc42bd70_.yxdb
[Result]
Fill [FieldName]
Result=Trim(
IF IsNull([__RecordID__]) THEN 'Field Missing' E...
FieldName=IF IsNull([FieldName]) THEN [Name] ELSE [FieldName]...
Allow
Join by: Name-FieldName
Allow All Multidimensional
Simple
Result
IsNotEmpty
!IsEmpty([Result])
Output28
Horizontal
Question
Macro Output (28)
Question
Macro Input (29)
Question
Macro Input (30)
DataValidation
Tab
Questions
Tab (27)
MacroOutput
Macro Output (28)
Macro Output (28)
MacroInput
Macro Input (29)
Macro Input (29)
MacroInput
Macro Input (30)
Macro Input (30)
Macro