In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Disable input tool auto data field

terrellchong
8 - Asteroid

I have a set of table that looks like this

 

ItemAmountQuantity
 RMRM
   
Laptop1000150
Table500150
Chair1200150

 

when i import it from XLSB into alteryx, it turns into this

 

Item Quantity
  RM
   
Laptop1000150
Table500150
Chair1200150

 

The "Amount RM" went missing, the Column "Item" and "Quantity" is V_string, whereas "Amount RM" turns into double, hence removing the table title.

 

I am using the macro from this link :Batch Macro to import multiple file having differe... - Alteryx Community

1 REPLY 1
ArtApa
Alteryx
Alteryx

Hi @terrellchong - If you could provide your file and workflow that would help.

Labels
Top Solution Authors