Replies posted by khatkechetana

11 Replies

khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Hi Genietim, Thank you so much for your reply. we will create setup and try this python script to execute for expected result 

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Regarding Trigger When 2 files drop to SFTP folder or we can schedule a time at what time it can run.

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

1) you have two Pipefy tables and want to find the difference to put it into another table. The first question is: what is a difference for you? Do you want to put every row of the two tables in there, which is not in the other table? Or just if it is in one and not in the other? Or only if they differ in certain fields? Does the order/index matter or just the values?Answer: a) We need to compare 2 tables A and B and find the difference in C table and also compare B and A table and find the difference in D table.("HEAD COUNT RECONCILIATION").    present in A table not Not in B table --> difference in C table  and present in B table not in A table ---> difference in D table.b) Order/index not matters here.   Table A     Table B   Employee_ID Status  salary Emp_id Status  salary 1 Active  10K 2 Active  20K       3 Active  30K  2) Where are the original CSV/Excel coming from, how often will they “come again”, how often does this duplicate

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Hi genietim, Actually Now we are done with the import excel sheet through Importer app and CSV files through EasyCSV tool connected with Zapier we are able to import both the files data to 2 tables of Pipefy.We are able to fetch the record from pipefy 2 tables through graphql query.Now we are trying to do the header mapping from 2 tables and findout the difference in https://app.pipefy.com/graphiqlWe need to map the header like this // Map the headers of the two tables for comparisonconst headerMapping = {  'Table1 Header A': 'Table2 Header X',  'Table1 Header B': 'Table2 Header Y',  // Add more mappings as needed};however we feel that this complexity is not possible to compare directly via api. so, we are thinking we can use Apollo server and try to code in graphql and merge with pipefy with all credentials and authorization tokens.Is it possible that Apollo server can connect with pipefy and do the header mapping and compare 2 tables data and find the difference?If yes then can anyon

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Hi Genietim,We are trying to implement custom code through Graphql to achieve compare 2 tables and findout the difference and stored it in 3rd table.We have done with below steps :Import the Excel sheet data and stored it into 1 table of pipefy. by using integration of Zapier, EasyCSV tool with Pipefy we have imported data and stored it into 2nd table of pipefy. Now we are stuck with comparison with header mapping with Graphql so, It would be really great if you can help me with the article or example of comparison with Graphql and connect with pipefy. 

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Thank you so much for your Quick response. It’s really appreciated.

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

hi genietim,Regarding This header mapping is not a problem with the importer.May I know  do we have any example or artical or video?

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Thank you so much for the information Genietim.Let me check what best I can do with various tools. Thanks & Regards,Chetana Khatke

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Hi Genietim,Thank you so much for your response It’s really appreciated.  at least it gives me an idea that we can integrate or write our own code to do it. also below are my understanding about Header mapping.Example you can consider we have 2 (Excel and CSV) files with different name of the fields1) Excel file : Employee_ID, Employee_Name, Employee_Email2) CSV file : Emp_ID, Emp_Name, Emp_Emailso, for comparing this will be difficult as the name of the fields are different so, we need to do the header_mapping Like Excel-> Employee_ID csv:->Emp_ID===> will be consider as a E_ID.That is one standard formatThanks,Chetana.

19
C
3 months ago
khatkechetana
khatkechetanaParticipating Frequently
asked in Finance & Procurement

Import Data from csv and excel files and do the header mapping automatically and and findout difference and stored it into 3rd table of database Export the report

Hi Team,Is it possible into pipefy application?  Thanks,Chetana

19
C
3 months ago
Rica
Pipefy Staff
RicaPipefy Staff
published in Tips and Inspiration

Export all users information in your orgProduct Hacks

How we can convert csv file to Excel file and compare each other and find out the difference?

3141
khatkechetana
11 months ago

Community Experts Leaderboard

Terms & ConditionsCookie settings