How to skip comment during onboarding delimiter type application

[puresoftware (aman singh)]

Hi,

I want to onboard delimiter type application but hader start from line number 15. I want to skip all comments from line 1 to 15.

[sunny_tsang]

You should read the documentation on how to set up a delimited file application. You definitely could set up a customization rule, but I recommend you keep it simple.

In your application definition, you can actually specify the number of lines to skip and designate your comment character: https://community.sailpoint.com/t5/Technical-White-Papers/Delimited-File-Application-Configuration/ta-p/74147

[pattabhi (Pattabhi Nandarapu)]

But 1st line is mandatory to keep headers otherwise test itself fail. There is a check box at File page whether to consider 1st line as header or data.

For example if you mention number of lines to skip 15 , then it will consider data from 17th line.

1st line is mandatory to keep headers then from 2nd to 16th line will skip.

But the challenge is: shifting hearder line other than 1st line is not feasible as per current system design.

[Muhammad_Mustafa]

Hi @puresoftware, it will work if your header and data start on lines 15, and you set the “Number of lines to skip” to 14 as exactly replied by @sunny_tsang.
I tried it just now and it worked for me

Have a nice and great one!

Regards,
Mustafa

[pattabhi (Pattabhi Nandarapu)]

Hi @Muhammad_Mustafa

I have tested on IIQ 8.5 and am getting the following error: Missing attribute columnNames.

I have tried the following scenarios, all resulting in the same error:

1. No mention of the number of lines.
2. Tried with 12, 13, 14, 15, with or without the filter empty flag.

Could you please clarify what I am missing here?

For his requirements, the source file’s header column is at line 15 (the first line of the file is excluded), and the actual data begins at line 16.

Thanks,
Pattabhi

[Muhammad_Mustafa]

Hi @pattabhi just add the columns names in the columns textfield separated by new line

Check and let me know if you need anything further brother
Have a nice and great weekend!

Regards,
Mustafa

[Muhammad_Mustafa]

Here you are some screenshots as well…

[pattabhi (Pattabhi Nandarapu)]

Thanks, @Muhammad_Mustafa.

Yes, it is working perfectly fine. I learned something new today.

[Muhammad_Mustafa]

You are more than welcome, glad to hear that it’s working fine now, and we are all learning from each other for sure

Have a nice and great weekend!