在所有行分组中重复一行
我需要在所有行中重复所有回答，直到下一个调查集。
我需要的示例是在最后一列中。
需要的是，我可以创建一个CAR参数过滤器来获取所有答案行。
我尝试了一些方法，但没有成功。
有可能吗？
非常感谢您的任何帮助。
surv_id date_time question_id question answer_id answer car
CAR_CHECK1 30/03/2022 08:42 5169 type 4509 return to supplier RMN9H51
CAR_CHECK1 30/03/2022 08:43 5132 date_time 4624 2022-03-30-08.43.00 RMN9H51
CAR_CHECK1 30/03/2022 08:43 5174 car group 4629 V RMN9H51
CAR_CHECK1 30/03/2022 08:48 5134 car 4632 RMN9H51 RMN9H51
CAR_CHECK1 30/03/2022 08:48 5135 car km 4633 51389 RMN9H51
CAR_CHECK1 30/03/2022 08:48 5142 picture 4634 YES RMN9H51
CAR_CHECK1 30/03/2022 08:55 5166 signature 4627 SIGNATURE RMN9H51
CAR_CHECK1 30/03/2022 10:42 5169 type 4509 return to supplier AAA1525
CAR_CHECK1 30/03/2022 10:43 5132 date_time 4624 2022-03-30-08.43.00 AAA1525
CAR_CHECK1 30/03/2022 10:43 5174 car group 4629 V AAA1525
CAR_CHECK1 30/03/2022 10:48 5134 car 4632 AAA1525 AAA1525
CAR_CHECK1 30/03/2022 10:48 5135 car km 4633 51389 AAA1525
CAR_CHECK1 30/03/2022 10:48 5142 picture 4634 YES AAA1525
CAR_CHECK1 30/03/2022 10:55 5166 signature 4627 SIGNATURE AAA1525
CAR_CHECK1 01/04/2022 10:42 5169 type 4509 return to supplier CCC1122
CAR_CHECK1 01/04/2022 10:42 5132 date_time 4624 2022-03-30-08.43.00 CCC1122
CAR_CHECK1 01/04/2022 10:42 5174 car group 4629 V CCC1122
CAR_CHECK1 01/04/2022 10:42 5134 car 4632 CCC1122 CCC1122
CAR_CHECK1 01/04/2022 10:42 5135 car km 4633 51389 CCC1122
CAR_CHECK1 01/04/2022 10:42 5142 picture 4634 YES CCC1122
CAR_CHECK1 01/04/2022 10:42 5166 signature 4627 SIGNATURE CCC1122
I need to repeat the car answer in all rows until the next survey set of answer.
The example I need is in the last column.
The need is with this way, I can create a car parameter filter to fetch all the answer rows.
I've tried some ways but no success.
Is that possible?
Thanks a lot for any help.
surv_id date_time question_id question answer_id answer car
CAR_CHECK1 30/03/2022 08:42 5169 type 4509 return to supplier RMN9H51
CAR_CHECK1 30/03/2022 08:43 5132 date_time 4624 2022-03-30-08.43.00 RMN9H51
CAR_CHECK1 30/03/2022 08:43 5174 car group 4629 V RMN9H51
CAR_CHECK1 30/03/2022 08:48 5134 car 4632 RMN9H51 RMN9H51
CAR_CHECK1 30/03/2022 08:48 5135 car km 4633 51389 RMN9H51
CAR_CHECK1 30/03/2022 08:48 5142 picture 4634 YES RMN9H51
CAR_CHECK1 30/03/2022 08:55 5166 signature 4627 SIGNATURE RMN9H51
CAR_CHECK1 30/03/2022 10:42 5169 type 4509 return to supplier AAA1525
CAR_CHECK1 30/03/2022 10:43 5132 date_time 4624 2022-03-30-08.43.00 AAA1525
CAR_CHECK1 30/03/2022 10:43 5174 car group 4629 V AAA1525
CAR_CHECK1 30/03/2022 10:48 5134 car 4632 AAA1525 AAA1525
CAR_CHECK1 30/03/2022 10:48 5135 car km 4633 51389 AAA1525
CAR_CHECK1 30/03/2022 10:48 5142 picture 4634 YES AAA1525
CAR_CHECK1 30/03/2022 10:55 5166 signature 4627 SIGNATURE AAA1525
CAR_CHECK1 01/04/2022 10:42 5169 type 4509 return to supplier CCC1122
CAR_CHECK1 01/04/2022 10:42 5132 date_time 4624 2022-03-30-08.43.00 CCC1122
CAR_CHECK1 01/04/2022 10:42 5174 car group 4629 V CCC1122
CAR_CHECK1 01/04/2022 10:42 5134 car 4632 CCC1122 CCC1122
CAR_CHECK1 01/04/2022 10:42 5135 car km 4633 51389 CCC1122
CAR_CHECK1 01/04/2022 10:42 5142 picture 4634 YES CCC1122
CAR_CHECK1 01/04/2022 10:42 5166 signature 4627 SIGNATURE CCC1122
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论