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

Question

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.

MSugantha · Answer

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) 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

Aguisande · Answer

Hi @MSugantha

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

Have you checked the encoding of those files?