List of Contributions

Rubal Grewal

Contact Details

My Content

1 to 10 of 10 total

RE: Excel template data appended in opposite direction

Posted By Rubal Grewal 02-14-2021 20:29
Found In Egroup: Data360 Analyze \ view thread
Thank you Gerry for the quick code but the pivot is still getting distorted as the date is "15/02/2021" in this format and cant be changed to "2021-02-15". The moment I refresh on pivot after creating the file, the data gets displayed with distorted details in pivot.

RE: Excel template data appended in opposite direction

Posted By Rubal Grewal 02-14-2021 15:48
Found In Egroup: Data360 Analyze \ view thread
Thank you so much Gerard for the quick response but I have tried leaving "Output spec" blank so that data gets appended at the end but still the data gets added at the top instead of bottom in the excel. So not really sure what needs to be changed in specification properties

Excel template data appended in opposite direction

Posted By Rubal Grewal 02-11-2021 20:48
Found In Egroup: Data360 Analyze \ view thread
I am using a template (excel file) that has some data and pivot already created by another team. I need to write new data to that excel file at the end so that existing data is not touched and pivot information can be updated. I am able to write new data using the updated excel as a template but it is ...

RE: Pivot table and date column issue

Posted By Rubal Grewal 01-28-2021 19:23
Found In Egroup: Data360 Analyze \ view thread
Thank you so much Adrian for the quick support. Really appreciate it. But can you please let me know if it is possible to append the data in excel and update pivot instead of recreating it. As when same file is read and updated , there are high chances that some details may get missed and overwriting ...

Pivot table and date column issue

Posted By Rubal Grewal 01-27-2021 16:37
Found In Egroup: Data360 Analyze \ view thread
I am reading the report for customers where the date and amount transferred is mentioned and create a pivot table. But if I am passing the date attributes then it gets reflected as “28-01-2021” and pivot is able to pick. But the client requires a date in “28/01/2021” and I converted the data into a different ...

double quotes issue in output text file

Posted By Rubal Grewal 09-28-2020 23:02
Found In Egroup: Data360 Analyze \ view thread
I am creating an output file "XYZ.txt" based on some logic but double quotes are getting added in the final data. There are 3 inputs to a cat file (all string) but for the middle input double quotes are added. I have kept blank for all the properties option in the CSV/ Delimiter option. Can someone please ...

RE: Dynamic Sheet in Excel

Posted By Rubal Grewal 09-24-2020 17:03
Found In Egroup: Data360 Analyze \ view thread
It worked fine Gerry but for the output excel, it is just writing new data. The old worksheets present in the file are not getting reflected in the new file. Also, for the tab name in the new sheet generated, how can I make it dynamic based on the current year and month.

RE: Dynamic Sheet in Excel

Posted By Rubal Grewal 09-23-2020 15:37
Found In Egroup: Data360 Analyze \ view thread
You are awesome Gerry!!! Thank you so much for the quick support and the sample shared. I will test it and share the update... Really Appreciate your efforts

Dynamic Sheet in Excel

Posted By Rubal Grewal 09-22-2020 22:30
Found In Egroup: Data360 Analyze \ view thread
I am reading a file which contains month-wise data and updates the file based on some logic. If the excel contains the "current month" tab then I need to append new data to the existing data sheet in the current month tab and not touch other tabs. If the current month is not present then I need to add ...

Text file creation issue

Posted By Rubal Grewal 09-21-2020 03:03
Found In Egroup: Data360 Analyze \ view thread
I am trying to create a text file based on some data input from different sources but not able to understand how to create file with extension txt. The contents contain pipe and comma separated data. Can someone please suggest a way forward. Thank you in advance for your support. Attached files ...