Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I have source oracle table and there is one column called txn_date.
values are:
txn_date
02-06-2017
04-06-2017
07-06-2017
04-06-2017
Requirement: How to create folder based on date for examples:
folder 1: c;/Txn_dt_02-06-2017/
folder 2 :c:/Txn_dt_04-06-2017/
folder 3 :c:/Txn_dt_07-06-2017/
But no duplicate folder even if same records with same date arrive.
and is possible to store single context variable to store unique txn_dt values?
Thanks
Shree
Hi,
Sure, Let start work on it. let you if i face any issue.
Thanks
Shree
Sure, i will start work on it, let you know if i face any issues.
Thanks
Shree
Hi,
I have attached job screen shot.
(1)tOracleInput -->(2)tMapRow---> (3)tFlowToIterate ---iterate--> (4)tOracleInput -----> (5)tFileOutputExcel
tOracleInput_1 : "select distinct txn_dt from REC_TAB_MTN_CBANK" // Got 2 distinct dates
I have used tmap: Just pass though.
tFlowToIterate : Just pass though.
tOracleInput _2: i can see two time executed.
tFileOutputExcel: checked (Create directory if doesn't exist)
"C:/Users/DELL PC/Desktop/out.xlsx"+((Integer)globalMap.get("tFlowToIterate_1_CURRENT_ITERATION"))
Output: two files are created.
No folder created.
The files created not xlsx format.
I not good in global map, i am missing this one. Can you help me on this.
Thanks
Shree
Hi,
May i know input and suggestion for next step.
Thanks
Shree
This is working as you have coded it. The two files have been created on your desktop. The following code.....
"C:/Users/DELL PC/Desktop/out.xlsx"+((Integer)globalMap.get("tFlowToIterate_1_CURRENT_ITERATION"))
.... is creating files called "out.xlsx"+{the iteration number} to your desktop. If you want folders to be created you have to change this path to the path you want to create.
Hi,
I have changed folder path. No expected result.
I have attached screen shot your references.
Observation:
1) File Output format is wrong. ( .xlsx1 )
2) Both file is same means same records are passing both files. it's not inserting the records based on txn_dt.
3) No folder are created based on txn_dt.
Thanks
Shree
Hi,
I am sharing job documentation. It will really help for find out problem.
Please find the attched xip file. Open Mutiple_Folder_0.1 (HTML file)
Thanks
Hi,
Please ignore last attached file. Find the latest attached zip file.
Thanks
Shree
Your file path (the thing I mentioned in my last post) is wrong. You are not using the same logic as before. Regardless of the content of the files, you need to sort that files and folder right first. The file path must include your date folder and you seemed to have this working in the past. Go back to how you calculated the path then.
The reason you have 1 and 2 after the ".xlsx" file extension is because you are appending the current iteration value.
Hi,
I have messed lot of things here.
Could you please created job and share with me, let me check where am doing wrong.
Thanks
Shree