Anyone aware on how to insert the data into excel file from a specific line number? My requirement is to insert/create the data in excel file from line number 6. From lines 1-5 I will have the header information. We designed all pipelines to read the...
Hi there,I have one input json like as follows:{ "isValid": true, "logId": "9IE9BkOwxvrCwn_Ot7p4o-1699858392", "contractId": 1, "erpVendorId": "VID123", "erpVendorName": null, "erpVendorLocationId": "VSID789", "vendor": [ ...
I have a input json file like below please see the dummy example below{ "totalCount": 2, "dataList": [ { "IFA": "IFA1", "voltage": "200", "power": "100", "equipid": "1234ABC", "SN": "SalesForce-1" }, { "IFA": "IFA2", "voltage": "200", "power": "100",...
Running into an issue I can't solve.I'm unable to have Snap create a table (if not present) with a DATE datatype field (instead of a string datatype) if the first import row encountered is a null or empty date string. That is, I want the newly creat...
As long as before, when I add expression library, it appears the "=" button as below. But now, the "=" button doesn't appear like the picture. How can I get expr file from parameter?
Hello,I would like to delete/replace some characters (typically .) from headers in xlsx or csv file before loading the file in SQL Server using bulk load. Does someone has any idea ? Thanks.
We are currently facing an issue following the 4.35 update where the Ultra Task is encountering the following error:No Active Feed Masters found from. The feed master is up and running and files are waiting in queue.We have tried to implement the fol...
From the very first, I have data stream like as below[{"report_pipeline_id":"5fac56734418fe353b7b846d","transaction_id":"72479d9c-85f4-4cc6-90ec-dffac6d8536a","client_id":"e2572c18-29de-46c1-a212-fa54f61e468f"},...]later step is CSV Formatter, this s...
