Need help with table expansion

Question

hi&nbsp;Can somebody help me fix this problem&nbsp;in query editor when I click on the table expansion icon below ...&nbsp;It shows that the table has 17 columns which is correct&nbsp;&nbsp;&nbsp;&nbsp;when I click OK , it expands the table BUT it does NOT display the first column from source file . The first column as shown below is the name of the source file. The second column shown below is the second column of source file. At the end it has created an additional 18th column which is null . Not sure why its happening . Any help would be appreciated&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Anonymous

lbendlin · Answer

According to your screenshot this works nominally.&nbsp; The "Name"&nbsp; column is there.&nbsp; Please explain your issue again.

ashwinkolte · Answer

The issue is this&nbsp; ==&gt; "Data.Column1" in the above screenshot is second column of the source Table which I expand . what happened to first column ?&nbsp;Basically on expanding the data i.e clicking on the expand icon , It is skipping the first column of the underlying data and instead creating a column with null values as last column in leau of the first column&nbsp;&nbsp;

ashwinkolte · Answer

2 seconds agoThe issue is this&nbsp; ==&gt; "Data.Column1" in the above screenshot is second column of the source Table which I expand . what happened to first column ?&nbsp;Basically on expanding the data i.e clicking on the expand icon , It is skipping the first column of the underlying data and instead creating a column with null values as last column in leau of the first column&nbsp;&nbsp;