rashmi
New Contributor III
Joined 4 years ago
User Profile
User Widgets
Contributions
Redshift queries with multiple create and 1 select
Hi All, Is it possible to run multiple create statement first to create multiple temp tables and select statement (redshift query) which has to then fetch columns from those temp tables and need to run in one session i tried executing using Redshift - Execute but it was not giving me column name as result set but instead giving me [{“status”:0,“message”:“success”}] as resultset which is resultset of just creating temp tables and not giving the select statement resultset i also tried to use Redshift - Multi Execute but it has was failing at select statement as it doesnt support Any help is appreciated Thanks4.3KViews0likes4CommentsFetching query from configuration file
Hi All, I wanted to write query with value from inputstream but fetch the query from the configuration file/ json file which is stored in sldb instead of writing query directly in the snap for example if consider this statement i am using inside the snap it should evaluate to this query SELECT * FROM app_0046_customervoice.rcur_bfo_ACCOUNT WHERE SEACCOUNTID__C IN (‘0001088191’,‘0021088450’)); do i have to escape any character as i am getting syntax error when i am am using it in expression/configuration file input: [ { “SE_ACCOUNT_IDs”: “0001088191’,'0021088450” } ] Any help is appreciated!2.5KViews0likes3CommentsRe: Replace value according to its poition
hi @alchemiz the column keys in group array maynot be characters like A,B,C… its suppose to map based on the position like col1,col2 etc the expression suggested by @bojanvelevski $group.map((x,index)=>$[‘@id’] == index + 1 ? (x.mapValues((v,k)=> $col.find(e => e[‘@id’]-1 == x.keys().indexOf(k)) != null ? $col.find(e => e[‘@id’]-1 == x.keys().indexOf(k) ).get(‘$’) : v)) : x) works irrespective of column name in group array but its should be tweaked to satisfy my input becoz in which he had metioned $[‘@id’] comes in as filed but in my case it comes in as an array element like this jsonPath($, “row[][‘@id’]") and also $col comes in as an array but in my case it comes in under row array like this jsonPath($, "row[].col”), so i need help in adjusting the above expression to satisfy my input.Please could u help 😔1.7KViews0likes3CommentsRe: Replace value according to its poition
hi @alchemiz thanks for helping but thats not exact requirement actually there are two arrays in input called row and group and each looks like this as shown below so according to position values (rowid & colid) need to update values of second array (group array)only expected output:1.6KViews0likes5Comments