Hi Could you please attached my Requirement file.
I need to be load a file Row 18 before Row data I don't want itNote: Source file I have a Password (Encrypted File) I'm not able to load Encrypted file in community Please Suggest to me........
@Ajith1 You should do something like this:
Please, if you have any different questions unrelated to the original post, please assign a solution to this post and open a new post.
Pedro.
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.
@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.
@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.
@pedrodrfaria
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/R-Code-based-excel-file-reading/m-p/700364#M163062is it possible to Please share with me the Updated workflow for my reference
See attached for the workflow.
Please assign the solution for the discussion post. It really helps us.
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.
Hi @pedrodrfaria Thank you for me your Effort 😊
It will be showing Wrong Data please attached my Screenshots FYR.
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?
@pedrodrfaria Please find attached a screenshot
Can you provide a screenshot to how the data looks right after the R tool?
Is the configuration on the select records exactly where you wish to start the data?
The below solution works for MAC & Windows
Python based solution -
from ayx import Package
from ayx import AlteryxPackage.installPackages(['pandas','xlwings'])
import pandas as pdimport xlwings as xw
//place your path here
PATH = r'C:\Users\smrit\OneDrive\Documents\Alteryx\Book2.xlsx'
wb = xw.Book(PATH,password='12345')
// I renamed my sheet1 as samplesheet = wb.sheets['sample']
df = sheet[sheet.used_range.address].options(pd.DataFrame, index=False, header=True).valuedf
