Read Mainframe data file(txt format) with few packed decimals in Alteryx

[MSugantha]

Hi 

I'm trying to read some Mainframe data file(txt format) with few packed decimals in Alteryx. I have created xml from the copybook and read the data file by specifying the xml. I'm able to read the text contents from the input file but the packed decimals are showing as special characters .

Could any of you guide me if there is any method available in Alteryx to read such columns? Thanks in advance.

[Aguisande]

Hi @MSugantha 

Can you show/share at least 1 file of those?

Have you checked the encoding of those files?

[MSugantha]

Hi @Aquisande

The below is one of the sample from copybook

XXX PIC S9(07)V99 COMP-3.

i've written the column in xml as below,(assuming the length of XXX as 2)

<field name ="XXX"  type="V_String" length="2"><translate type="BCD"/></field>

I'm able to see the results since the length of the column XXX is unknown, the columns proceeding XXX might be read wrong.

Could you please help reading the binary/packed decimal column in the data file