negi_sagar
New Contributor II
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: error 3 upstreams for join
My team is facing the same issue. We did what you said by making the columns consistent but it is still giving us the same issue. Can you edit this pipeline and tell what exactly is changed. <Just change json to slp> It is a small pipeline with the sample data or 2 rows.1.1KViews0likes0CommentsEmail Azure SQL Servers Extracts
I work with SQL Server and Snaplogic Tasks. So we do some calculations on backend and create end tables on sql DBs which are reflected on power bi dashboards. My team members who handle power bi dashboards ask for table extracts from us in the form of excel or csv file. So this has become a repititive task where we open our SSMS and run our select queries and send them the extract. My team does not have access to Snaplogic and SQL DB and they also do not know how to work with these services and tools. The table extracts file size can vary from 100MB - 5GB I want to automate this. The two ideas which I can think of is: 1. My team will send table name to an email account which will trigger a task and run pipeline on snaplogic which basically runs Azure SQL Execute Snap and parses it to an excel or csv file. (If this is possible) 2. I can create multiple task links for each table which on a click will trigger the pipeline and will parse an excel or csv file through the Azure SQL Execute Snap which basically runs a simple select query. Now after an excel or csv file is generated I want users can access it. If the file can be emailed to them or sent on saved on my Gdrive or OneDrive. Please let me know if this is possible or something similar to this and it will be really helpful if you can help me with detailed steps as I'm new with snaplogic.1.5KViews0likes0CommentsHelp with adding a field in JSON output
I have a JSON output like this: { "Choices": { "1": { "Display":"Generating standard, automated reports (e.g. ERP, reporting tools)?" } "2": { "Display":"Generating non-standard / custom reports (e.g. spreadsheets)?" } "3": { "Display":"Responding to Ad Hoc data requests?" } "4": { "Display":"Reconciling, combining, or manipulating data across multiple systems, reports, tools, and excel sheets?" } "5": { "Display":"Analyzing data and building insights?" } "6": { "Display":"Other" } } "QuestionText_Unsafe": "Tools and Reporting</br></br>On an average, what percentage of your time in a given week is spent:" "DisplayDataExportTag": null "DisplayLogic": null} This is one of the result and have multiple like this. So here I have this Field “Choices” where I have these values in numbers then another Child Field “Display” Now I want antoher field with Display which will be TextEntry: “true” but only for the last one or the max one. So for eg: here in choices the last/max field is 6: "6": { "Display":"Other" } It should be like this: "6": { "Display":"Other", "TextEntry":"true" } How do I do that? I’m new to the language.Solved