Alteryx Designer Desktop Discussions

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

Error in Table Tool

Dittau
8 - Asteroid

I’m getting in error in the table tool because some of the data in the table columns are blank. How do i tell the table tool to include blank data in specific columns?

3 REPLIES 3
gautiergodard
13 - Pulsar

@Dittau would you be able to provide a sample of your data or anything so i can replicate the error?

Dittau
8 - Asteroid

Imagine an excel sheet…getting an error the “column d” is not contained in the record “has a header and could contain data but this run it doesn’t” and also in column b if some data but not all data in rows

 

column a| column b | column c | column d

15              Chicken        Soda  

12                                    Pop

 

 

also, the table has a “table mode” basic and a a per column configuration…donyou click the headers to want to appear in both places or just one?

BS_THE_ANALYST
14 - Magnetar

@Dittau Am I missing something here? Seems to be okay for me:
i.e. input:

BS_THE_ANALYST_0-1680201568806.png


Output:

BS_THE_ANALYST_1-1680201577333.png


I didn't do anything, just dragged the Table tool onto the canvas.

 

Labels