@Thar11027  yes, but it will be more complex: you can put a shift operation and using the "*" wildcard. So if for example you do this: [ { "operation": "shift", "spec": { "*": { "*/*": "[&1].&", //with a '/' in the middle somewhere "/*":"[&1].&", //with a '/' at the start followed by something "*/":"[&1].&" //with a '/' at the end following something } } } ] You will obtain all the desired fields, so it will be more easy to do the manual substitution(try it on the jolt demo site). Know that if you want to make it full automated, it will be a little more difficult, because then you would have to manipulate the string of the field. If you are interested in that I really suggest you to look at the last example on the guide I already sent you (My Guide). (I don't know if maybe it will be more appropriate to open another question about this other problem, because the topic changed and maybe if someone with the same problem is searching for it, it can be found) ... View more

@sibin Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks. ... View more

@adsejnf Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks. ... View more

Hi had checked the "show processlist" and this query is running there and multiple time it's running problem is that it is scanning all rows, means not in optimize state and if it is auto generated query then how we can pass the partition information. and this query is not run by user, they are running optimize query it seems it taking some metadata from mysql, something like below..... So that's why i was thinking it meta generated query.  | id | select_type | table | partitions | type  | possible_keys                    | key             | key_len | ref         | rows    | filtered | Extra       | +----+-------------+-------+------------+-------+----------------------------------+-----------------+---------+-------------+---------+----------+-------------+ |  1 | SIMPLE      | C0    | NULL       | const | PRIMARY,UNIQUE_DATABASE,CTLG_FK1 | UNIQUE_DATABASE | 389     | const,const |       1 |   100.00 | Using index | |  1 | SIMPLE      | B0    | NULL       | const | PRIMARY,UNIQUETABLE,TBLS_N49     | UNIQUETABLE     | 268     | const,const |       1 |   100.00 | Using index | |  1 | SIMPLE      | A0    | NULL       | ref   | PARTITIONS_N49                   | PARTITIONS_N49  | 9       | const       | 5555098 |    11.11 | Using where ... View more

@Racketmojster Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@donaldo71 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@alan18080 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@Sofia71 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@npdell Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks. ... View more