Password Encrypted Excel file Sorcee

[Ajith1]

Hi 

Could you please attached my Requirement file.

I need to be load a file Row 18 before Row data  I don't want it

Note: Source file I have a Password (Encrypted File) I'm not able to load Encrypted file in community 

Please Suggest to me........

[pedrodrfaria]

Hi @Ajith1 

You can select the range if there is a specific range you want to pull data from

Or you can select you want to begin from line X. See option #7 in the configuration.

Pedro.

[Ajith1]

@pedrodrfaria 

But in my requirement, I have an Encrypted Excel File.

Note: Due Alteryx Community Guidelines I'm Not able to load the Sample file please attached my file.

[pedrodrfaria]

@Ajith1 

If you want to not use R and accomplish the same thing, even with an encrypted file:

After you run the R to open the encrypted file, add a select records and a dynamic rename afterwards to begin from the exact point you need.

Pedro.

[Ajith1]

@pedrodrfaria 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/R-Code-based-excel-file-reading/m-p/70...

is it possible to Please share with me the Updated workflow for my reference

[pedrodrfaria]

See attached for the workflow.

Please assign the solution for the discussion post. It really helps us.

Pedro.

[pedrodrfaria]

Here is one example taking in an encrypted file, using R to open it and using the select records and dynamic rename to begin from a specific row.

Pedro.

[Ajith1]

Hi @pedrodrfaria 

Thank you for me your Effort 😊

It will be showing Wrong Data please attached my Screenshots FYR.

[pedrodrfaria]

Sorry @Ajith1  I'm not really sure what you mean. The workflow you sent is not doing the Select Records + Dynamic Rename logic that we were discussing right now.

Was the workflow I sent you the solution you were looking for?

Pedro.

[Ajith1]

@pedrodrfaria 

Please find attached a screenshot