Field Names not mapping

[Karthick461]

Hello,

 I am reading txt files ( tab as delimiter). it has around 88 columns. I have used \0 as delimeter and text to columns as split and Dynamic Rename to bring first row as field names.

When i execute, around after 50 columns, my columns names truncated and 51st column shows Field_51 , then field_52,....

Not getting original field names. its working till column 49 or 50. 

Also last few columns not showing any records instead it shows Null for all

Any way to fix this

[Luke_C]

Hi @Karthick461 

A few questions:

1. Are all the field boxes checked in the dynamic rename tool?
2. For the null columns, are there sufficient delimiters in your data to populate them? Maybe you configured too many columns in the text to columns tool.

[Karthick461]

Hi @Luke_C ,

Yes. All fields checked in at Dynamic Rename

Delimeter is there , but still shows null

Attached Sample file

[Luke_C · Accepted solution]

Hi @Karthick461 

Seems to be working fine:

[Karthick461]

Hi @Luke_C ,

 I tried changing Field Length to 1000 from 254. It worked. Thanks for your assistance

[Luke_C]

@Karthick461 Ah that would do it! Be sure to mark the solution. Glad you're all set.