Dynamic Excel Input (Different Schema)
Macro To Read Directory (MultipleSchemas)
\\CDTSAPP5047P.production.imsglobal.com\AlteryxWorkflows\Workspace\002 Macros\Supporting Macros\System Macros\EXCEL Template.xlsx|||`Sheet1$`
False
1
EXCEL Template.xlsx
Query=`Sheet1$`
Saved name
D
Horizontal
Question
ControlParam.Control Parameter (3)
Question
Numeric Up Down (10)
Question
Check Box (14)
Dynamic Excel Input (different schema)
This tool will allow you to read multiple excel files with different data schema.
GFSS Input
schema, excel, different
Nikoleta Notova
IQVIA Inc
IQVIA Inc
NoCondition
(Always Run)
UpdateValue
Simple
8/File
UpdateValue
Simple
8/FormatSpecificOptions/ImportLine
UpdateValue
Simple
8/FormatSpecificOptions/FirstRowData
Tab
Questions
Tab (1)
Label
Kindly note that if you don’t have any other tool connected to the macro's output, the macro is unaware of how many iterations should run. Hence it only runs a single iteration returning a single row.
Label (24)
LabelGroup
Tool Configuration
LabelGroup (25)
ControlParam
Full Path
Control Parameter (3)
NumericUpDown
Start Data Import on Line
Numeric Up Down (10)
BooleanGroup
First Row Contains Data
Check Box (14)
Label
Label (16)
Label
Label (17)
Label
Label (18)
MacroOutput
Macro Output (5)
Macro Output (4)
Macro
iVBORw0KGgoAAAANSUhEUgAAAKsAAACrCAYAAAAZ6GwZAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAAEHpJREFUeF7tnQl4FEUWx2d1V5jhUBF38QSP1TWuzCQI4oGgoHgrAuqKuoriKuq6ri66nwoIXiiokJ5JwhlQznDfagDlPuVGboGACQloyEHIRW294X0rDC/TOaarq2fen+/3fRDmVb/q+qe7prq6ysVisVgsFovFYrFYLN00ofOZrpRmHpcRV/e8oTfVY2ITV7+r6wV9MCHuLFcv1xnoDg2U0uwPtf3XX1In4GvnDnj/5fbHb3L7fUc8/vhiiWBiD9n++W7D94PH8CV5DO/TnkDTeNdQaWA7dVZi06s8fm8PmdR0SRGVOMNItnv8vsQ6RkKX4FVXqQZeWd8TiH9HJrCMTcpUFnm1zZF33lluv/chdJK1qm3EN/YEfFPYpEx1kabNlYbtbWl/tlaSt4m8mi6iEmCYqlLH7xvWYGCL+mivyEl2mpvLS/g66qAMU13cRvxod5L3IrRZzVUnOeE6adY11MEYpoYUy7t1smt8SzfarfqqPyCugSxsrKSUOBDDRIJ8GFVCy1Vf8tb/ivwyVUYcgGEih+ErqZXobYO2q7o8RvNGZMEMYwm+5Z7PEi5A+1VBveLOkv3UGXShDGMBhq/QbfherPKQVu1BCa1gEJcslGEsQnY7Z9dNadYQbVg5yaA+Mpj7qoxaDF9R7UHem9GG5gJny6DpZGEMYzFuI6EfWtFcbqPpDdwFYOxCeu8IzOZDO4aXx/B2owphGFXUSbzuOrRjeLn9vhSqAIZRhfzO9ALaMbz40SpjO4ZvItoxvKRZYaY/XQjDKMG3Cu0YXnQww6hDfslaj3YMLyqYYdTi24F2DC86mGFUwmZlHAOblXEMbFbGMbBZGcfAZmUcA5uVcQxsVsYxsFkZx8BmZRyDZma9PPUOkbplilh1cJMyVmZtFH1WBMS5yTeQOVWG+knXi+m755PlW0nC2I5kPtGJhlfW4ZsnCdXKLMwRlwy7jcynMrSd9Iw4VPQrlqZGa7O3iMtGtCPziU40NOuN4x8TucfysEnU6d1lg8h8zKgbaCbeW+EXJeWlWJL12pefKbql9xR1/AlkTlGJ4ZuEdgwvMthC0rZ/jc2iThn5WaLJiLZkPuG4VF6RZ/30PZaiRndPe57MJZpBK5qLCraSa0bdK46VFWPTqNObi/uT+YTj5gmPi5yjv2AJ1it931Iyj2gHrWguKthqAuvHYPOo02r5paXx8KpdXV9f1A+j1cg3ugOZR7SDVjQXFWw1cMU6UpyPTaRGv8q+8hNf9yDzqYilP6/FaOs1aec3okFKSzKPaAetaC4q2Gr+NOQWMXrrDHFc/lGpEVumiIaDbyJzCuWaUfdglPUqKCkUj899g8wjFkArmosKVgE0Tq7iq2tmQbZo+tWDZD6hDN44AaOs1+IDa6rcRYkm0IrmooJV8MfBN4vlWeuxudTpo1WDyXxO5qKhraWxczDCenWf34fMI1ZAK5qLClbFgzNewuZSp6Olx8hcTuaxOf8WRWXHMMJaQd+9Jk/YogG0ormoYJXA0xrV+nBlMpkLAA8CxmydiZ+0VuXHy8XDM18h84gl0IrmooJV0mHmy6JIXu1Uak/egQofwV775f1iVdZG/KS1grkLMfWkqgLQiuaiglUCppm3bzk2nxoVlhaJ7gvofmIHeaUrKDmKn7RO8AvabV5PModYA61oLipYJXDbfW3hR7IvWYTNqEYTd3wjLhx662n5fL42FT9hrZZlrhN/GXXPacePRdCK5qKCVXNFanux+fBObEY1yisuEK3SupySR51AgsgrKcBPWKey42Xifdlv5i7ACdCK5qKC7QCGlFSr3+qhp+TQbkpX/B9rlVV4SP6C3nnKsWMZtKK5qGA7uHT47cFGVKlfjh2RXYHW/89heaaacd/ey41T6h7roBXNRQXbRY9Fn2JzqtMHK1OCx772y/vwJ9ZqZ+5ecQHRV45l0IrmooLtAmbH7/h1LzarGu0vOBh8mvbxqiH4E2v1+sJ+ZN1jGbSiuahgu4CRgXeWDsRmVaOS8hLx1uIBYs6ehfgT67RFfon0xug0wHCgFc1FBdtJ64lPid1H9mPzqtHO3H1if34W/ssawQjAgB9SRf2k5mS9Yxm0ormoYDs5WzbmyC1TsYmjR9lHD4sbJ/yNrHOsg1Y0FxVsN9Co0SZ4s7ee7OZQ9Y110IrmooLtpm4gQUzdmY7NHB1qPPx2sq6Mw80KNBpyiygtL8Omdra+WDuKrCNzArSiuahgHYCRgVE/Or/vCgtkeEc/RNaROQFa0VxUsC7cM+0fyldDiaTgHbOhmyeKhik3kvVjToBWNBcVrAuNhrQSsxUvMhFJwQgAvA1B1Y35DbSiuahgneiW/m5w4N6J+n7/quBQHFUv5jfQiuaignUjIy8Tm985gocA0I2h6mMlN46v2rAfPIChylEJWtFcVLBuPD7nDdn45Xh6naH0fcvIulgNm1UDVmRuwNOrv+CN1XaTu5L1sBo2qwbA0j9O6btO3vmtOL+SK79EGjarBsD7SvDeku7KLc4TXeb+h6yDCtismgCLAqtc2Lc6WnRgtWhi46rVbFZNgCdBP8mTq7NenP8embsq2Kwa8cmaYXia9dPGQ9uD62RReauCzaoRFw9rIzILs/FU66XH5rxO5qwSNqtm9F5h4KnWR7Dw8DlJLch8VcJm1QxYjwpeRdFFsEfCSwv6arFoBZtVM85LaSkGrhulzXzXNQc3i79+9QCZq2rYrBpyx5Rngxuy2S1YtrLviqTgToRUnqphs2rIOcktRNoO9XtqhQq6AFemtidztAM2q6a0nvhkcHaTnYKlK6ncIgG8LQGbhVSFdpOfwcwqJ1irlirHDCrf6oJWNBcV7CTSts/F026Ptv6ym8wrEiSM6YhH0U9UvtUFrWguKthJwKIYdr36Al/wrJyzymYNERXsJGB207hts/EUqhVsXwlrulJ5RQI2a4ioYCcBY5vw5OhwUS6eRnWCTeConCIFmzVEVLCTALM+P6+nkn0AQgVLy8MKhFRekYDNGiIq2ElcMOTW4CskdinVwqsrmzVEVLCT6DTrVeWbZ5ysvOJCMq9IwGYNERXsJNbl/Iinzx7BOKtVT6/YrCGigp1C12/fVr6zdqhKy0ste42FzRoiKtgJwFOUDTnb8NTZq9k/LRTnW/BFi80aIipYd2Bs81l5VYVXnnUQTKi5d9oLZK41gc0aIipYd+DVkWm75uFp00ODN04Q9QKR7btCPV9b+HGV6L9mBGZUOcHTP6ocM6h8qwta0VxUsO7cNbWbLeOq4QRX+T+PvIvMVyU860ozZu7+Dk+1XoK9EKh8VcJm1Yj2U57D06ynmo3tROatCjarJsDS7XY+raqMoO8KE8Op/FXAZtWER2a/ps0IQEWCHRLBMFT+KmCzagDsdzp+22xx/Li9DwHMBHNcey5LtO2dLDarBrSZ9HeRc/QXPMV6C1ZmgV2+qXpYDZtVA2B2k5ME6whQ9bAaNqvNNB/bWeSVFODpdYZ25e4Tlw5Tf3Vls9rMPM1HACoS7LZN1cdK2Kw2Ak+r7JyvWhPBRJsrUu8k62UVbFabgO3O03bY+6p1TVRQUii6z3/P0pcKQ2Gz2sRtk54OLsLgZMH0QVimk6qfFbBZbQCuRp/9kIqn1Lk6UlwgHpjRnayjFbBZbaDJiLYip8gZ46pm+mbvErKOVgBv28LCG5Xldnn3ospRCVrRXFSwDgzdNBGb2vmClQZhAg5VT8bhZoWZS9Gm7/avFOcm30DWN9ZBK5qLCrYTaNAhm9KwiaNHvx7LEx1mvEzWOdZBK5qLCraTVmlPiF25GdjE1urg0cP4N+sFXYERWyZbuoKLU0ErmosKtgsYV31/ZbKS5dcLS4vEW0sG4L/U6EDBQdFy/KNk3WMZtKK5qGC7OLFtkJql1+fsWRScGbU372f8iRp9snoYWfdYBq1oLirYLt5b4ccmtVawHfwH8goOx7xv2gvBW7Qq5cq+6yXDbjut7rEMWtFcVLAdXD3ybpFfUohNaq2yZV8V5sfCcWGxjHU5W/F/1Chpw9jT6h/LoBXNRQXbQcrG8diU1mtN9mZxNm6wBuv2v730C6XLEOUVF4i+KwK2TdDWDbcR/ynaMbyoYNVcP7aT2Jm7F5vSenVLf/eU49+S1kX5JnBg2Pumv3hKHrGLbwfaMbzoYHXAYsC9l6vb3hIWUqPymGrDCi+jt87UYldC+3GIWWEPKZXLVlbUX3xgenf8hDrBEN01o+4l84ktHGLWlxf0xaazXkVlxaLNxKfIPAB40U+15u5dTOYSWzjArA0H3yQy8rOw2azXwgOrRePhbclcgNZpT+In1Qm+2Okw88leHGBWeFqlUrDHat0ws/bh/2CkQLVgW08qn9hBc7PCu0kqnx5lBddQNd9gDXZ+gYcGKrX7SIa4deKTZD6xgcZmhXVMYWwTNulVpeVZ68UFQ1qR+ZxM83GdxZbDuzBKneDpXaTXd3UOGpv1qpF3i2WZ67CZ1KjPigCZSygwRREeUKh8BAuCdQYaVeKXKTrR2KywcUVxWQk2kxqF+2IVCrzuYcfr3zALjMon+tHYrD8pfmN16q50Mo+KgEewyzPXY7Q6lZSXkPlEP5qa9cX5vbFp1KjsePV2rn5wxktK5tWGCvquVD7RjYZmbSJvxT8XZGOzqNGmQzvEhUNbk/mYobpfDdpwaJu4fMQdZD7Ri4Zm/e+Sz+WtrhSbRY36rxkuzk5qTuZjxrPp7yjPF95geEHefah8ohfNzAo7mcATJJWCbXNgb1cqn8pw7Vf3i7XZ6rfb/HbfEnGRwlVc7Eczs3ac9U9sCnValbWxxgujwaowdmy52WJcZzKf6EQzs36/fyU2gzr5148hc6kK8NwertCqtUjehWBUgsop+tDMrMkbxinnpgmPk7lUBdgb4MNVKWT5VhM7i2Jo+AWLYWjYrIxjYLMyjoHNyjgGNivjGNisjGNgszKOgc3KOAY2K+MY2KyMY2CzMo6Bzco4hkqa1e2Pz6MLYBg1SA9uQzuGl9uIz6YKYBhVuP2+BWjH8JIfXhAazDBq8X2GdgwveQn+iC6AYdTgDsR3RDuGlzTrw1QBDKMMI64R2jG8PIkJCdKw3G9lbEH2V9PRiuaql9j8PI8RP4UqiGGsxm34OqEVK6FerjNkUA/JsZMLYRgFZNQKXH85OrFycg++7mKP4csgCmMY6zC8fteAlm60YeXl8fsSZQHHTyuQYSxA9lUPu5O8HdB+VVP9AXENZAE/UAUzTKSRX+rHoPWqJ08gob0siLsDjKVIo66tlZxwBdqumurVuLbsDvxXFlgQegCGiQy+PXUHJbRCx9VQssMrC518+kEYpma4DXkRTPQ9ByNQ6LbIyBPwjZMH4OEsJlLk1wn4Xkd7RVgpzTzyAP3dhi835KAMUxXK5RV1u7z4PYfOskZnj/Ce4zHiu7r9vq1EEgxjRrn0zlyP33unS7h+h7ayVh7D65MHflv+hhwMSYZhSOQdeUttw/tIrUFNL3N1dp2JVlKkXq1/7zLi6soEungMvtIyFWDE7649KP5RGLdXdjUNqwlxZ3kCCc1kYhkev6+cTJpRSYG83f6onvi18sK1TP59rLz7Ph28iuoqmeSrsuOcJLsHIxn78CTGv4lNwmKxWCxWhXK5/gfAZSArzunJZQAAAABJRU5ErkJggg==
AutoByName
Control Parameter (3)
Full Path